/*
 * Copyright (c) 2022-present Charles7c Authors. All Rights Reserved.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package top.continew.admin.asset.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import top.continew.admin.asset.model.resp.CheckTaskDetailResp;

import top.continew.admin.common.config.mybatis.DataPermissionMapper;
import top.continew.admin.asset.model.entity.CheckTaskDO;
import top.continew.starter.extension.datapermission.annotation.DataPermission;

/**
 * 盘点任务 Mapper
 *
 * @author CharlieYan
 * @since 2025/07/11 15:07
 */
public interface CheckTaskMapper extends DataPermissionMapper<CheckTaskDO> {

    /**
     * 分页查询列表
     *
     * @param page         分页条件
     * @param queryWrapper 查询条件
     * @return 分页列表信息
     */
    @DataPermission(tableAlias = "tt")
    IPage<CheckTaskDetailResp> selectCheckTasksPage(@Param("page") IPage<CheckTaskDO> page,
                                                    @Param(Constants.WRAPPER) QueryWrapper<CheckTaskDO> queryWrapper);

    /**
     * 查询盘点任务详情
     *
     * @param id ID
     * @return 盘点任务详情
     */
    CheckTaskDetailResp selectCheckTaskById(@Param("id") Long id);

    /**
     * 查询盘点任务未盘点数量
     *
     * @param taskId 任务ID
     * @return 查询盘点任务未盘点数量
     */
    @Select("select SUM(CASE WHEN STATUS = 0 THEN 1 ELSE 0 END) AS not_checked from check_item where task_id = #{taskId}")
    Integer selectNotCheckedCount(@Param("taskId") Long taskId);

    /**
     *
     * @param taskId 任务ID
     * @param status 更新的状态
     * @return
     */
    @Update("UPDATE check_task SET status = #{status} WHERE id = #{taskId} ")
    Integer updateCheckTaskStatus(@Param("taskId") Long taskId, @Param("status") Integer status);

}